Create the following tables in the Northwind database:Regions table Column Name Datatype Primary Key (Y/N) Nullable (Y/N) RegionID Integer Y N RegionDescription Character (50) N N Departments table Column Name Datatype Primary Key (Y/N)

jdmvin

Create the following tables in the Northwind database:
- Regions table
  Column Name
  Datatype
  Primary Key (Y/N)
  Nullable (Y/N)
  RegionID
  Integer
  Y
  N
  RegionDescription
  Character (50)
  N
  N
- Departments table
  Column Name
  Datatype
  Primary Key (Y/N)
  Nullable (Y/N)
  DepartmentID
  Integer
  Y
  N
  DepartmentDescription
  Character (50)
  N
  N
Insert the following data into the 2 tables:
- Regions table
  1
  Eastern
  2
  Western
  3
  Northern
  4
  Southern
- Departments table
  10
  CEO
  20
  Sales
  30
  Marketing
Alter the Employees table, and add a column:
- Employees table
  Column Name
  Datatype
  Primary Key (Y/N)
  Nullable (Y/N)
  DepartmentID
  Integer
  N
  Y
Alter the Employee table to establish a foreign key between Employees and Departments.
- Employees.DepartmentID references Departments.DepartmentID
Alter the Territories table to establish a foreign key between Territories and Regions.
- Territories.RegionID references Regions.RegionID
Update the data in the Employees table so that employees with the following managers are listed as working in the following departments:
ReportsTo
Department
Andrew Fuller
Sales
Steven Buchanan
Marketing
All Others
CEO

Answer(0)

Bids(1)

other Questions(10)